﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CarSpecHundredOilUsingRpt.aspx.cs"
    Inherits="Auto.BusMan.Report.CarSpecHundredOilUsingRpt" %>

<%@ Register Assembly="Chartlet" Namespace="FanG" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <cc1:Chartlet ID="Chartlet1" runat="server" ChartTitle="同类车型百公里油耗" 
            ChartType="Bar" XUnit="车辆牌号" YUnit="百公里油耗" MaxValueY="100" Height="500px" 
            Width="750px" />
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnString %>" 
        ProviderName="System.Data.SqlClient" SelectCommand="  SELECT bl.BusIdentificationNO
      --,b.[CompanyName],bl.BusSpec
      ,100*(SUM(b.[OilVolumeByCard])+SUM(b.[OilVolumeByCash]))/MAX(b.[OdometerBus]) AS HundredOilUsing
  --INTO A
  FROM [Bus_BusOilManage] b
  LEFT JOIN Bus_BusList bl ON bl.BusID=b.BusID
  LEFT JOIN Bus_Drivers d ON d.DriverID=b.DriverID
  GROUP BY bl.BusIdentificationNO,b.CompanyName,bl.BusSpec"></asp:SqlDataSource>
    </form>
</body>
</html>
